Jump to content

script/related fields, searching data? help?


This topic is 8243 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 8243 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.