linking two tables in the one form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stuart - 30 Apr 2007 10:20 GMT

I have a database which has various tables, queries and reports running
within it. I have tried to create a input form which will allow me to click a
tick box, so that once the tick choice has been made it relates the
information being put in to the correct table. I am trying to do this to save
me duplicating my work into the tables separately. When ever I have tried to
link or build the expression builder it comes up with various issues. Please
advise!!!

Thank you

Reply to this Message

Scott McDaniel - 30 Apr 2007 11:34 GMT

>I have a database which has various tables, queries and reports running
>within it. I have tried to create a input form which will allow me to click a
[quoted text clipped - 3 lines]
>link or build the expression builder it comes up with various issues. Please
>advise!!!

You'd have to explain a bit more about your database structure. Are you saying that you have ONE input form and wish to
have data from that form put into different tables based on a checkbox? If that's the case, you might have some issues
with your database structure IF you're using different tables to store identical data (for example, if you have January
table, a February table, etc).

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

Reply to this Message

John W. Vinson - 30 Apr 2007 17:16 GMT

>I have a database which has various tables, queries and reports running
>within it. I have tried to create a input form which will allow me to click a
[quoted text clipped - 5 lines]
>
>Thank you

What are these tables!? It sounds like you have two or more tables with
identical structure. If so you should really reconsider your table design;
instead, consider using ONE table with an additional field (containing what is
now your table names, or a synonym).

John W. Vinson [MVP]

Reply to this Message