relationship problem?

[Carlos]

Here goes

I have created a database which holds all of the users information including what software they have. For the software i have created a seperate database. For each bit of software i have created a new record. Each record has a number, e.g 001,002 and so on. This is the field i am using to link the 2 databases. So in the user information database i have a field which is linked to the field in the software database, and once this number is tapped in it will drag all the other information from that database e.g. name of software, version etc.I have created at least 10 of these fields all linking to this one field in the software database. So whn i do a search in the user information db it will not find anything unless i type the number in the specific field out of the 10.

Hope this makes sense.

Any ideas?

cheers

Carlos

[LiveOak]

Not all of it. Why do you have 10 fields in the User database?

-bd

[Kurt Knippel]

quote:

---

Originally posted by LiveOak:

Not all of it. Why do you have 10 fields in the User database?

---

More to the point, what is the structure (fields and relationships) of the databases?