Open table with specific ending

[ALESLUCI]

Hello
My problem is that I have 30 tables which all starts with "mdok" etc. mdok001, mdok020, mdok120. The numbers 001, 020, 120 are ID for my custumers.
I have my basic table with custumers id's and name's.
So when I in form select desired custumer name it should read data from his ID , and make's reports from this data

please for advice!

 

[beetee]

Howdy,

Here's some advice you might consider:

Create a single table.
- Add a customer ID field into the new table.
- Append each individual table to the new table, using the suffix as the customer ID.
- You will probably want to create one query using the design tool, then hand edit the sql to modify for each table.

Use filters on your form to select a specific customer.