How to reduce amount of fields needed?

[Linda]

I have a Table and form for the entry of Bus Route costs
by route. Now my boss wants to split up the entry by
departure city and arrival city. I have this table and
form already setup for Departure city (One-to-many)
relationship. Can I copy the table to a table II and copy
my form to form II so I do not have to add double the
fields to Table and create a form with new fields (arrival
vs Departure) ?

 

[John Vinson]

I have a Table and form for the entry of Bus Route costs
by route. Now my boss wants to split up the entry by
departure city and arrival city. I have this table and
form already setup for Departure city (One-to-many)
relationship. Can I copy the table to a table II and copy
my form to form II so I do not have to add double the
fields to Table and create a form with new fields (arrival
vs Departure) ?

That shouldn't be necessary; maybe I'm not understanding the table
structure correctly, but I'd suggest just adding one new field,
ArrivalCity, to the routes table. You can have *TWO* one to many
relationships from the Cities table to the Routes table, one linking
to DepartureCity and the other to ArrivalCity.

If this isn't making sense, please post a description of the structure
of your table (and perhaps your proposed Table II).