Unanswered: Using two tables or related tables on one form
Hi everyone, hope you can help?
I have designed a repairs management database for our company, which is used to generate paper work for dispatching repairs to manufactures, the databes records phone type, date sent etc.
I want to have a section where you can select which loan phone number has been issued (all our loan handsets are identified by number) and then have the make,model,IMEI populate automatically once the number is selected.
I have created another table alongside the main table that contains this information but can't figure out how to assign these fields, do i need a certian type of relationship, do i need to have two tables on one form?
I'm sure there is a way and it is right in front of my eyes but i just can't see it, can anyone please help.