Just an FYI so we are clear. You would set up the BAQ and the Quick Search. After the Quick Search is set up, your users would just click on the Job button, bring up the search screen, select the Quick Search you set up, click search and then enter the Job number and ASM seq number and click search and ..... well what I wrote before covers the rest.
key field for the JobAsmbl table..... not sure the AssemblySeq ALONE is the key field. It seems that (as with other db systems) Vantage derives many of it's key's from several fields. So, for example, the JobAsmbl unique key would be the combination of Company,JobNum & AsmSeq. But like I said, not sure how JobAsmbl is set up. The Data Dictionary in Vantage may help you here.
key field for the JobAsmbl table..... not sure the AssemblySeq ALONE is the key field. It seems that (as with other db systems) Vantage derives many of it's key's from several fields. So, for example, the JobAsmbl unique key would be the combination of Company,JobNum & AsmSeq. But like I said, not sure how JobAsmbl is set up. The Data Dictionary in Vantage may help you here.
--- In vantage@yahoogroups.com, "eivantage" <KYLEJ@...> wrote:
>
> Wow... I really appreciate the fact that you took the time to come up with that. You did teach me a few things in there, but I can't tell my users to do this... there would be mutiny just explaining it to them!
>
> As to the other question, these are assembly sequence numbers, as in the JobAsmbl.AssemblySeq integer field. I guess you would call this field the key field for that table.
>