Ms Access Form displaying 2 or more unrelated tables (1 Viewer)

[anandan.cr@gmail.com]

Query 1 : In Ms Access, I Wish to Create transaction Form linked with Multiple unrelated tables (Transaction Table, Flight Master, Item Master). Snapshot attached
Query 2 : Item Master Table Master Item change dynamic and data entered against it thus it should be in Grid Format/ Sub Form

Kindly suggest , How to create the above.

How to create it.

 

[Uncle Gizmo]

Please explain your business process, as I believe you could benefit from some advice on how to construct an MS Access Database in the correct manner.

 

[anandan.cr@gmail.com]

Please find below the requisite details :

Transaction (Table-1)
We are in trying to enter Delivery order(Transaction Form) for In-Flight Catering Services Project, wherein Delivery Order is fed for Meal Order received from SpiceJet Airlines for Specific flight e.g. Flight No. SG131.


Flight Meal Master(Table-2) :
This Table takes the count of Economy Class Non-Veg (EY-N VEG) and EY-VEG Meals like that Crew Meals and Cockpit Crew Meals (N VEG/VEG).


Item Master(Table-3), Category wise data input : i.e Menu's Qty ,Standard Item's Qty and Ex Airlines Item's Qty.

From this table we are feeding our inputs against the items mentioned in the already Dynamic Fed Menu (Menu IDs’e.g. :CH00002, CH0004 Etc). This should save only the menu items against which the quantity is fed in transaction table. And the same should be applied for the Item Master(Table-Standard Items) & Item Master-(Ex Airlines) also.

Query1: How to create Transaction Form( Need to enter data from table1, Table-2 and Table-3),
Flight Meal Master(Table-2) and Table1: Transaction and are related with One to Many Relationship,
but Item Master it not related with any of the above mentioned tables

Query2: Marked in RED

 

[arnelgp]

you need to Add Master/Child Link Fields to each subform.

 

[Pat Hartman]

Unless you are creating some sort of status form that shows multiple unrelated stats, you would not typically put unrelated data on the same form. Your form appears to have a bound main form and multiple subforms. The tables the subforms are based on should be related to the table of the main form. Then as arnel suggested, you would use master/child links to keep all the forms synchronized. If you create actual relationships using the relationship window (as you should), that gives Access certain information so that when you add a new subform, Access can automatically create the proper master/child links for you. Without that knowledge, Access cannot help you. You will need to make the relationships manually yourself.