form with fields from multi tables

%3CLINGO-SUB%20id%3D%22lingo-sub-309243%22%20slang%3D%22en-US%22%3Eform%20with%20fields%20from%20multi%20tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-309243%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20i'm%20trying%20to%20create%20a%20form%20that%20has%20fields%20from%20many%20tables%20(employee%20information%20table%2C%20employee%20contact%20table%20and%20employee%20location%20table)%20using%20a%20form%20wizard%20or%20blank%20form.%20i%20did%20selected%20the%20fields%20from%20each%20table%2C%20but%20unfortunately%20it%20didn't%20work.%20i'm%20getting%20(Name%23)%20in%20all%20the%20fields%20instead%20of%20having%20the%20data.%20can%20any%20body%20help%3F%20by%20the%20way%20first%20and%20second%20tables%20are%20one-many%2C%20first%20and%20third%20table%20are%20many-many%20using%20another%20table%20for%20the%20relation%20ship.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-309243%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-314287%22%20slang%3D%22de-DE%22%3ERe%3A%20form%20with%20fields%20from%20multi%20tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-314287%22%20slang%3D%22de-DE%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F260717%22%20target%3D%22_blank%22%3E%40JoeQar%3C%2FA%3E!%3C%2FP%3E%3CP%3EDo%20you%20know%20something%20about%20relationships%20between%20tables%20in%20MS%20Access%3F%20I%20suggest%20you%20create%20a%20query%20from%20your%20fields%20and%20different%20tables%20must%20have%20a%20relationship%20with%20primary%20and%20foreign%20keys.%20With%20that%20query%20you%20can%20create%20a%20form%20as%20source%20from%20those%20different%20fields.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20don't%20know%20what%20i%20am%20talking%20about%20pls.%20send%20a%20screenshot%20so%20that%20i%20can%20figure%20out%20how%20to%20help.%20Greets%2C%20Eva.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi, i'm trying to create a form that has fields from many tables (employee information table, employee contact table and employee location table) using a form wizard or blank form. i did selected the fields from each table, but unfortunately it didn't work. i'm getting (Name#) in all the fields instead of having the data. can any body help? by the way first and second tables are one-many, first and third table are many-many using another table for the relation ship.

2 Replies
Highlighted

Hi @JoeQar!

Do you know something about relationships between tables in MS Access? I suggest you create a query from your fields and different tables  must have a relationship with primary and foreign keys. With that query you can create a form as source from those different fields.

 

If you don't know what i am talking about pls. send a screenshot so that i can figure out how to help. Greets, Eva.

Highlighted

Hi @JoeQar ! Tables are only to store the data in MS Access, so i suggest to make a autoform upon your tables. Its very good to have 1-n-Relationships between them. Try this: You can select the (customers, detail) table on the left navigation, then pls. click on "Create" tab - FORM, pic 8 and 9 additionally here. I made a quick tutorial for you in here with a new database, concerning customers and requests in a call center.  Requesttable is now the so called Master table, which is nested as a second form INSIDE the main form. Hope you dont mind that a few german labels are in there.

Greets, Eva.