linking two tables in the one form

[Guest]

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

 

[Scott McDaniel]

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!!!

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

 

[John W. Vinson]

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

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]