Jan 18 2007, 02:43 PM
Just wondering what your opinions where on how the user should enter information into a table without actually going into the table view? Thanks.
Jan 18 2007, 02:51 PM
The short answer is a bound Form.
Jan 18 2007, 02:57 PM
I forgot to explain this but the data on the form needs to be from two different tables. But when i create a form from a query that includes both tables and try to enter new information with the form it tells me that is can't find a certain field. For example an ID field. If its a new ID that is not already in the Database it will not insert it into the table. Does that make sense?
Jan 18 2007, 03:30 PM
Are the tables related?
Is the query updateable?
Jan 18 2007, 03:31 PM
So many questions to ask...
Are your tables related?
Have you thought of a sub-form?
Is the ID an autonumber field? On both tables?
Can you provide a little more detail on your tables?
Jan 18 2007, 03:46 PM
Here is the database with the two tables in it. I have put a made up record in there to show you how the tables are related.
Jan 18 2007, 04:08 PM
See the attached.
I added some primary keys that are autonumber and updated your insert appt form.
Is this what you want?
Edited by: HiTechCoach on Thu Jan 18 16:14:56 EST 2007.
Jan 18 2007, 04:47 PM
Jan 18 2007, 10:35 PM
Glad we could assist.
Good luck on your project ...
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here