If I have that correct, you want a table of "shops" with one reocrd from each shop created from your current table of "visits" that has multiple records on each shop.
In your new shops table select a Unique values/validate always field option on a field that uniquely identify each shop. If no single field will do that, you can set up a new text field that uses an auto-enter calculation to combine data from several fields and set your unique values validaiton option on it.
Then you can use import records to import the data from visits into shops and the unique values setting will automatically filter out the duplicates.
Hmmmm. Sounds good, but just testing that I understand ...
Not having much luck. Tried to test the auto-enter calculation to combine data from several fields, but can't get that simple step to work. Done it before, but just tried over & over without any result.
Will try to evaluate the rest of your suggestion when I pass this obstacle!
Please ignore my previous post: pretty dumb. Sorry.
What is not obvious to me is importing record data from one table to another. I can import from an external file into a new table, but not into an existing table with a different name, or so it seems. My original database has only one table, named "Table". I am trying to set up a new file with at least 2 tables, eg, Visits and Shops, using all the record data from the original file.
I get how to set up the identifier with unique values, but don't seem to understand how to import the existing data into the new table.
You can import data into a different table of the same file but not the same table. You go through the same steps just as though importing from a different file, but pick the file you already have open. But make sure that you have defined a new table and not just made a new Tutorial: What are Table Occurrences? for it on your relationships graph.
I don't see why you would want to import into the same table of the same file.
A miracle! It worked, after a bit of experimentation.
Done it again PhilModJunk! Thank you, thank you!