reverted to an old version and this is workin...

[Kevin_Richard]

reverted to an old version and this is working again

I’m having issues with a Ref to another table ID getting put in when I add a record to the child table.

I have done this in other tables on the same app and it works, but from Customer to Order it’s leaving the “CustomerID” blank everytime I create a new order for a customer.

I know that is vague in way but that’s the thing… it seems vague.

Second column is set to Ref and in the details I pick the CustomerInfo Table and it picks up that it needs the CustomerID as the ReferencedKeyColumn.

I have it set to readonly and required, but every new order I create just leaves that field blank.

Then when it shows records for that customer it list every record because they all match.

Which they shouldn’t because it’s set to select based on CustomerID matching.

Hmmm

Any ideas?

Do I need to just delete that table and start again?