2 tables linking them

[superrob5]

I have a helpdesk and jobs table


I have also 2 forms

A helpdesk can turn into many jobs. A job can be by itself

how can I create a link where a helpdesk can have muliple jobs and how to I force it the job number ?

I creatd a table called
HelpJobRef
with helpdesk and job a a field which will hold the numbers.


how do I get the numbers in them

 

[WayneRyan]

super,

You need to make a form for your Help Calls. It will
have HelpID, DateReported, PersonReporting, CurrentStatus
and some other fields. Make a form for this, use the
wizard if you must.

Then with your form in design view, make a subform to
hold the Job information. HelpID (same as above),
JobID, JobDescription, JobStatus, etc.

The forms are related by the HelpID field. So right
click on the subform and put HelpID in both the
Master-Child links.

All that's left to do is to make the default value for
the subform's HelpID: Forms![YourMainForm]![HelpID].

Access will do all of the synchronizing of your records
for you.

Wayne

 

[superrob5]

the other solution I came up is. Create an extra field in teh job table called Helpdesk number. So when I click on the button that I force the helpdesk number to the job. Becasue not all helpdesk are jobs.