Adding Info

[Sarah Byrne]

Hi I am new to access and this problem may seem really easy but I cant for the life of me figure it out. I have created a database that allows you to see the jobs that we are working on, what parts we have used on that job and so on and so forth. I am stuck with, when Im on an individual job, I want a list of parts that we have used. I have a separate 'part' form that you can add parts to but cant figure out how to get them to form a list when there in my individual job. I can only add one part to each job and each job has many!!

Any help would be helpful.

 

[Old Man Devin]

First, on the parts table have a field that stores what job a part is for.

Second, create a parts form (tabular layout) to pick all the details EXCEPT the job.

Third, add this as a subform in your jobs form, and when prompted by the wizard, say that you want to link the job on the jobs form to the job on the parts form (it will probably try to do this automatically, so you can likely just click okay on everything).

Now the subform on jobs will display a list of all the parts for that job. Any parts added through this job form will automatically be recorded as being for the currently selected job.

Do let me know if you have questions on the specifics of all this!

 

[Sarah Byrne]

First, on the parts table have a field that stores what job a part is for.

Second, create a parts form (tabular layout) to pick all the details EXCEPT the job.

Third, add this as a subform in your jobs form, and when prompted by the wizard, say that you want to link the job on the jobs form to the job on the parts form (it will probably try to do this automatically, so you can likely just click okay on everything).

Now the subform on jobs will display a list of all the parts for that job. Any parts added through this job form will automatically be recorded as being for the currently selected job.

Do let me know if you have questions on the specifics of all this!

I want to cry lol. :banghead: Thank you for your reply. I am just trying to get my JobID to actually show up as now it has disappeared all together which is rather annoying. I'll let you know how it goes.