AnsweredAssumed Answered

Add new record in different table

Question asked by jackmac on Jul 19, 2018
Latest reply on Jul 20, 2018 by jackmac

Hi all,

 

I have two files:

 

Customer

Product

 

There is a table in the products file which lists all products sold and has a CustID field (line items sort of thing) and a field in Customer with the same name.

 

I have ticked the 'Allow creation of records' box when I created the relationship.  I press the button it does create a new record in Products and shows the CustID along with the fields I have said to add.  Next time I press the button it doesn't add a new record, it only updates the same record for that CustID.

 

I'm using:

 

SetField {Product::CustID ; Customer::CustID]

SetField {Product::Postcode ; Customer::Postcode]

 

Any ideas on how to get it to create a new record?

 

TIA

 

J

Outcomes