How to reduce amount of fields needed?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Linda - 20 Aug 2004 16:33 GMT

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) ?

Reply to this Message

John Vinson - 20 Aug 2004 19:33 GMT

>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
[quoted text clipped - 4 lines]
>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).

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

Reply to this Message