Inserting a reference id into a DB field

Ask the community
,
1

Is there any way to save, or insert or set a field value of a reference field into a DB without getting a “reference is broken” error? The simplest DB moves are head scratchers in Corvid…

I’ve been looking around the forum, playing around with code ideas, and… zip.

Right now I have this:

$w(‘#submitReviews’).setFieldValues({
drinkID: $w(‘#drinkList’).value,
rating: $w(‘#starRating’).value,
recommends: $w(‘#switch1’).value
});
});

Thanks in advance for any help!

2

I have the same issue this time - SQL queries 30 years ago was easier and much more powerfull! But it is at it is - I keep searching the forum :slight_smile:

3

Thanks for confirming that this should be a snap on something that is built to be a relational database. Wow!