How do I get multiple forms to open to the same record

[Guest]

I have an access file that has 14 tables that I linked from Excel (so I am
unable to set up and index, primary key, or lookup key). I set up
relationships for each table (they all have a field named city in them that I
set up as a relationship from table to table. I also set up forms from each
table.

What I would like to know is how can I get all of these forms to open up to
the same record when Access is first opened. And, how can I get the
tables/forms to be sychronized so when form 1 city 1 last field is edited the
user can go directly to form 2 city 1 field 1. And so on, throughout each
table. (Also, when a user finds a record, I would like the other forms to
change to the same record).

Thanks, I'm a new user so all help is appreciated.

 

[Ron2005]

I am assuming that you do not really mean same record but rather the
same corresponding record in each of the other tables.

Instead of having the forms based on the linked spreadsheets, have them
based on a query of the appropriate linked spreadsheets with the
criteria for all of them being something on your very first main form
or even the very first form using the spreadsheet instead of a query.

Queries of linked spreadsheets are allowable and work fine.

They could be forms placed on tabs off of a main form that selects what
city to look at.
All sorts of possibilities.

Hope this gives you some ideas.

Ron