var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to combine data from 2 tables into one
Application: MS Access 2000
I have two tables.
Table 1 is named ServerInfo which contains a field called "Servers". The Servers field contains names of servers.
Table 2 is named NetworkInfo which contains a field called "Device Name". This field contains names of network devices.
Both Tables 1 and 2 have additional fields which I do not currently care about
On a form I would like to have a one combo box that would let me display already entered values from Table 1 and 2, possibly storing it to another table
I am trying to figure this out for days, but I am not getting anywhere. Please help!!
Assuming you are trying to create a 'network', you would create your third table. Then have a form that looked up the information from table 1 and table 2 and the field should be bound to the third table. When you create your form, the first thing it asks is what data should the form be based on. For the form choose the thord table. Then add the two combo boxes and when the wizard asks you where to store the data, give it then name of the field in the third table.
Thank you for your reply, but it is still not workin for me
Yes, you are correct, I do have a Table 3 that is called "All Devices". - Table 3 should capture the data from Table 1 and 2 in a filed called "All Devices"
When I try to create a form, the first thing it asks me is "What fields do I want on the Form" - When the wizard is over the only thing it creates is a box for "All_Devices" field
Only During the "combo box" it asks me "on what data it should be based on"
Any other suggestions??
LOOK MY FRIEND
AND PUT TWO FILED FROM THE TWO TABLES THAT YOU WANT AND IN THE THIRD FILED IN THE QUERY BUT -- Not -REPET: ([SERVER] & "/" & [Device Name])
The answer is queries.
You can add fields from any number of tables by using a query. You can then use that query for the record source of a form or to populate combo boxes or list boxes.
Unless of course I am misunderstanding what you need.
Owner and Manager of
. , Microsoft Access Development Specialists CypherBYTE
Microsoft Access . MCP
And all around nice guy! "Heck it's something understood by accountants ... so it can't be 'that' difficult..."
"...teach a man to code and he'll be frustrated for life! "