New Record

[Guest]

Hi All
I have a Table that contains data relating to tendering for Jobs. The table
has a key called ID. When a Tender is won it then receives a Job number from
another table. Up till now all tenders could only have a single job attached.
The system is now changing and it should be possible to now have multiple
jobs linked to a single Tender.
The form that does this opens via a query that defines all the fields needed
including the Tender ID and the ContractID (these are the fields that are
linked) and a Job number field. I tried to add a button to add a new record
but this gives me both a new Tender ID and Job Number. Any Ideas how I should
approach this so I only have one Tender ID but muliple Job numbers?
Thanks

 

[jahoobob via AccessMonster.com]

You will need a separate table for the jobs offered under a tender with many
jobs to one tender relationship.
In the form, you will need a continuous subform for all the job numbers and
link this subform to the main form via the Tender ID.