Trouble with Lookup

[laurat]

I was instructed to build a database to keep track of scrapped parts. A form will also be manually filled out within the company (not sure why they are doing that but that's out of my hands). On this form there is a ticket No at the top and each ticket number can have up to four scrapped part numbers with their descriptions. In the database they want the part description to fill in on the form automatically when the part number is typed in. I figured that out using the lookup wizard. (Once the part number is typed, it looks it up in a separate part table) The problem I am running into is I don't know how exactly to handle this since there can be up to four part numbers for each record in the database. I hope I have explained myself clearly.

 

[ansentry]

I think you would need a main form with Ticket Number and a subform to hold the parts and descriptions.


Regards

 

[laurat]

Let me explain my set up a little, maybe that will help.

Main Table
Ticket No
Part No
Defect Code
Work Cener No
Clock No

Supervisor
Clock No
Supervisor
Employee

Work Center No
Work Center No
Work Cener Desc

Part
Part No
Part Desc

Defect Code
Defect Code
Defect Code Desc

They want one form to enter all info, and they want things to automatically fill in from the other tables, for example, when Part No is typed, the Description should fill in; when clock number is typed - the supervisor's name should fill in, etc. The trouble I am running into is that each ticket No can have up to 4 part numbers and four defect codes. How do I create the form to have four part no and 4 defect codes to fill in and how is each looked up and the description is filled in?

 

[ansentry]

Have a look at the attached sample, it was done very quickly - so allow for mistakes.

It may not be what you want but will give you some ideas.

As I am sure you know, with the drop down combo boxes you can either use the drop down list or enter data and it will find the item.

Regards,

 

[laurat]

Thank you!!

Thanks so much for the help, I am going to play around with it and see what I can do. My only question, is there a way to limit the number of Part Numbers entered into that subform?

Thanks again!!

 

[ansentry]

Have a look at the attached updated sample. 4 is the max records that can be added to the subform.

This should give you some basic ideas to finish your db.





Regards,