linking field data within one record

[harry8]

Our records have a 'district code.' I want each individual code to be 'linked' to a specific Web site address (written out -- not to open).

For example: in one record I will have a district code field, e.g. "1234". If I add to that same record a district web address field, it will contain the URL (written out) that is specific to "1234".

Further example:

District 1234 would be linked to www.sanfrancisco_sd.edu

District 1235 would be linked to www.sanbruno_sd.edu

How do I do this? thanks,

Harry

[Gerd Muller]

make a related db with the fields "district_code" and "url". The ditrict_code will be the match field.

if you fill out the district code in your main db, you can access the url from your related db

Gerd