Using a combobox on a form to select table

[rzardo]

Hi all,



I am new on here, so forgive me if I am posting in the wrong place.

I am trying to use one form to manage multiple unrelated tables that share the same field names (i.e. SKU, Name, Description) . My goal is to utilize a combobox or listbox to choose which table the data is sent to.

I have been researching this for two days with no luck. Please help.

Thanks.

[June7]

Why are these tables unrelated? Why do you have multiple tables with the same field structure? What you want can be done but I am confused as to why it is necessary.

If you want to provide db for analysis, follow instructions at bottom of my post.

[rzardo]

I think it is stupid too, don't worry.

I am making this for my mom's amazon and square stores. Apparently you have to export and submit each category as it's own file (books, jewelry, etc.), so she wants each category in its own table so that she can easily export the tables.

If you have a better idea I am definitely all ears. I am semi-experienced with access, but not with the importing and exporting features.

[June7]

Multiple tables same structure = bad design.

One table.

Use queries to filter records.

Export query.

[rzardo]

I didn't upload my file because it is virtually non existent at this point. I was trying to solve that one problem with a "dummy" file before I put too much time into the database. I didn't want to have to re-do everything if I need to go a different direction with the whole thing.

[June7]

Just add a Category (books, jewelry, etc.) field in the table. Then use query to filter for the desired Category. Export the query.

Review http://www.datapigtechnologies.com/f...earchform.html