Enter data into multiple tables from one form

[June7]

When you say you get an error, please provide exactly what that error is - error message, wrong result, nothing happens.

Fixes:

1. subform RecordSource can simply be TransactionTbl - SQL statement did not include all fields

2. set subform container Master/Child Links properties to CustID fields

3. bind Combo0 to VehRegNo field

4. make CardType a combobox

5. TransactionID textbox should be at least Locked Yes and TabStop No. Or don't even have this textbox. Users don't need to see this field.

 

[Ctang]

Hi June7

The error message is "you cannot add or change a record because the related record is required in table customertbl' . But I don't want to add or change anything in that table, all I want to do is add the transaction details into the transaction table.

 

[June7]

Did you try the fixes? Or examine the db provided by Mike to see what's different from yours?