Find Problem

[Nerdworld]

B):smirks:: you get past one problem you hit another.

I'm setting up and inventory database were the user clicks an update button and it checks if the part is in stock and if it is adds one to the used field in the inventory database and adds the part information the warranty database I'm haveing no problems getting that up and running.

Were I'm haveing the problem is when i have to update the work order i need to add the Part information which is in many fields to work order in one field and i have a field in the inventory database were the user tells which Tag(record) to update in the work orders any ideas?

[Vaughan]

Why is the part information in many fields... it sounds like you should have used a relational database...

[Geeksharka]

If you need to take data from many fields, and place it into one field (on the Work Order), I recommend the following.

Use the Set Field script, and assemble the multiple fields of data into one formatted field via a calculation. Especially if you throw some IF conditionals in there to deal with Empty fields, you can wind up with perfectly tailored output. The calcs can get a little long a hairy sometimes, but the logic is straightforward and easy to test.

I use this all the time to take a screen full of fields and output them in a way that 'reads' better for an invoice, work order, etc. etc.