Query Geanie Where Are You?

[Lamb2087]

I want to be able to type in a text box a serial number and have in another text box a slot number auto fill. Then I want to type in an id number that will auto fill a students name and housing. I want these to be added to each other in a table.So that a particular student_id and name wiil have a serial and slot number in the record int he table. I have a table with student id and name.
I have another table with the serial and slot numbers.

If some one can help it would be great.

 

[faceman]

Query Question

Gonna need some more details here...

Table 1: What fields do you have here?

Table 2: What fields do you have here?

Which field is the primary key for each table?

Why would you need to take the contents of 2 tables and combine them into 1 table?


Typically tables are set up into sets of fields that pertain to a piece of the whole. (ie Northwind DB = Consumer information table, product information table, supplier information, etc...)

Each table has a field as a unique identifier that only be on that one record. It can also have another table's PK in it as well.
(ie Product's table = Product_ID(PK), Supplier_ID, Product_Name, Product_Description, etc...)

You then set up your relations to meet whatever needs you have and create your query in which you tie your forms and reports to.


Faceman