Need to populate info in new form when it opens

Dave 14867

Registered User.
Local time
Today, 07:47
Joined
Jan 1, 2017
Messages
56
Hello all,

I have started a new database for tracking some info and have run into a snag. I have 2 tables, the first was created with imported from an excel file I was using and the second was created to start to track info on a per machine basis.

I need to have the second table "Instrument Issue Log" to be populated with some info from the first table when it opens, namely the "Instrument Serial_Num" and "Instrument_ID". I can seem to remember how to get the code correct to be able to access that info in the first table.

I want the form to open from the "Instrument History - Columnar" Table "Log Issue 3" Command button (Going to remove other buttons) and when the form opens have the fields already populated, or they can populate after the user enters their name.

I hope I have described my problem correctly.

I have attached the database.

Thanks

Dave
 

Attachments

jdraw,

I believe the new layout may be better after reading some of the material you had suggested, can you take a look and give me some feedback.

I guess I have just worked with excel so long it just seems natural to set the tables up that way and I must look at the info differently.

My proposed new layout is in the attached excel file ( I find it easiest to make the tables in Excel then import them)

Thanks

Dave
 

Attachments

Users who are viewing this thread

Back
Top Bottom