script/related fields, searching data? help?

[axis]

i have records that have fields: name, location, etc. and computer1, computer2, computer3 -under each computer box are 3 more fields: serial1, serial2, serial3.

what i want to do is click on a button (script) that will return computer1 with serial1 always... and so on for computer2... and 3, etc.

further what i REALLY want is for all 3 computers to come back with their serial numbers.

ultimately i will search my database for either a person's name to see what computer(s) they have or i will search by serial number(s) and return the person and all of their computer(s).

can someone PLEASE tell me how to do this!

Thank you in advance.

[LiveOak]

A better way to structure you whole solution is to use two files: People and Computers. Then you could perform a search in the computer file for a single entery of serial number. Your structural problem is the use on multiple serial number fields for multiple computers.

However, we can still overcome your bad structure. Create two global fields:

gName (text)

gSerial (text)

and a search script

Allow User Abort (off)

Set Error Capture (on)

Go to Layout (a new layout for entering the search data)

Set Field (gName, "")

Set Field (gSerial, "")

Pause <--- user enters serach info and hits return or a button you have defined as resume script

Enter Find Mode ()

Set Field (Name, gName)

New Record/Request

Set Field (serial1, gSerial)

New Record/Request

Set Field (serial2, gSerial)

New Record/Request

Set Field (serial3, gSerial)

Perform Find ()

Go to layout (layout to display results)

-bd