Many to One ?

L

Linda

Sorry about first post...
Tables:
BusRouteTble The "One" Table
Autonumber PK
Bus_number
Start_City
Start_Time
End_City
End_Time

Route_Fee_Code The "Many" Table
Autonumber PK
Fee_Type
Fee_Code

The BusRouteTable has one record for each trip

I need to add many Route_Fee_Codes to that record

I thought to build a Form to Enter the BusRouteTable
info and in it a subform to Enter Route_Fee_Codes

Then create a Report: For each Route all the Fee Codes

How can I create a relationship between them ?

Thanks again for your great support !!!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data to MS Access from csv file 0
Assistance with Many-to-Many Relationships 6
A many-to-many challenge 1
Access 2013: Form problem in reading data tables; relationship one-to-one 0
primary key - concatenated or autonumber? 6
"Multiple Autonumber" in same table 2
one to many or many to one 2
Multiple Many-to-Many relationships 10

Top