Creating a table with multiple foreign keys

M

macronon

Hi,

I have a question concerning the creation of a table that contains multiple
foreign keys. (tbl_ipaddress)
The table in question will contain information pertinent to IP addresses.
I'm trying to use this table to hold records containing the ip address for
many equipment types. Each of this equipment types has its own table which
corresponds to have a corresponding foreign key in the tbl_ipaddress.
My problem is when i create a new record for an ip record, will it be
correctly referenced to the corrected table (only one of the foreign keys
will assume a value). Will this setup work without problems?

Thanks for the help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Creating a Chart on form from selected data in query. 0
Sorting Multiple Tables 1
Problem with printing a word document containing a table 0
primary and foreign keys 0
Loading Table with Associated Foreign Table 5
Doughnut Chart linked with the slicer in the pivot table 0
Setting column width in a table with a macro is not working 0

Top