Multiple tables in 1 form ?

[baseborn]

With ms access can you to edit 2 tables with 1 form ? or i mean create a form that would allow you to do this ? example:


form input 1 "type first name"
form input 2 "type lastname"
form input 2 "choose a table" <----- drop down menu for selectiing table



SUBMIT

[pbaldy]

What do the different tables contain? The desire to be able to choose one usually indicates a design problem (tables for year, customer, etc).

[baseborn]

Hey thanks for the timely reply, what im doing is creating a form for entering my personal book collection into a database. basicly what exactly im needing is an input for the book title, input to post the url to amazon for info and then a drop down menu to select which category to place the book in so im guessing 2 ? i dont think i would have to create some type of relationship would i ?

[pbaldy]

So what tables are you choosing from? You didn't answer my question about what they contain. You probably shouldn't have tables for each category, if that's what you're doing.

[baseborn]

Im sorry, i had to re-think this one out lol. im going to have 2 tables. Books which will hold "P_Id", "Book Title" "Category ID" and a "Link" per record and Categories which will hold my 5 categories and their category id.

Input 1 will throw the title of the book into the "Books" table
DropBox input will let me select a category from the "Categories" table
Input 2 will throw the url in the "Books" table along with the title.

So i will be entering data into the "Books" table while selecting data from the "Categories" table.

[pbaldy]

That's a pretty standard setup. The combo box wizard should create that for you.