Field to relate records

[SteveJ]

Hi

I am abit of newbie when come to database design. What I am trying to do I think should be quite simple. Here it goes.

I have two diffrent tables one called computer details which has few fields below.

ComID Unquie ID

ComName

Model

Network No

Serial No

Subnet

IPAddress

The other table is IPaddress which hs the following fields.

ID_IP Unquie ID

IPAddress

Subnet

The relationship between the two tables is IPAddress.

So far stright forward. Now we have over 750 IPAddress spread over serval subnets. The IPAddress table will never be modified once its populated.

On the layout we have the Computer details and the IPAddress and Subnet.

The basic idea is that if somebody create a new computer details record they will need assign value of IPAddress and subnet. Both thes fields are drop down menu with values from the records of the IPAddress table.

The problem

Is there anyway using the Subnet Value list to slect subnet 123 then select the IPAddress and only show the record relate from the subnet 123 instead of showing all 750 records?

I have attached the file aswell give you clear picture of what I am trying to do.

Many Thanks

Steve

Computerstuff.fp7.zip

Edited July 7, 2006 by Guest

[Fitch]

First create a relationship based on Subnet, and then change your IP value list to use only related values from that relationship (in the value list dialog click Specify field and then the radio button at the bottom of the screen that follows).

[SteveJ]

Thanks for your help.

Cheers

Steve