Add Record for all related tables

[kronar30]

I have a form and subform. When user wishes to add a new job record how do I add all the records to related tables?

 

[CautionMP]

Make sure your relationships are all setup correctly, then set them to enforce referential integrity and cascade updates.

Just make sure that you form/subform provide all the required (key) fields in all the related tables to allow new records to be added.

CMP

 

[TheAceMan1]

How are ya kronar30 . . . . .

Sounds like your form/subform are not bound to the tables. Is this correct?

If so why not bind them?

See Ya! . . . . . .

 

[PHV]

And provided the RelationShips are properly set, simply follow the subform wizard.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[kronar30]

I went to Edit Relationship
All tables relate to the JB_Jobs table and the JB_JobBidNo field. The JBO_JobOverheads table relationship is a one to one relationship.
However when I try to set the enforce referential integrety I get an error "No unique index found for the referential field of the primary table"
It lets me set it for the one to many table!
help

 

[PHV]

For a one to one relationship you must have JobBidNo as Primary Key (or at least unique index) in both tables.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[kronar30]

The overheads table consists of about 6 records for each job record from the main table. So JobBidNo can't be Primary Key in the one to many relationship.
I think the form and sub-forms are bound to the tables, how would I tell?
Any more ideas? Thanks

 

[TheAceMan1]

[blue] . . . The JBO_JobOverheads table relationship is a one to one relationship . . .
The overheads table consists of about 6 records for each job record from the main table.[/blue]

[blue]This is a one to many relationship![/blue]

See Ya! . . . . . .