Forum Discussion
MarkShnier__You
2 years agoQrew Legend
What are the field ID#s for those two fields, respectively?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- AnithaJeevarath2 years agoQrew Cadet
Customer Id (FId - 6), Order Id (FId- 7), Book Id (FId - 9)
------------------------------
Anitha Jeevarathinam
------------------------------- MarkShnier__You2 years agoQrew Legend
Are you trying to have the records know if there exists other records with the same values for all three fields?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- AnithaJeevarath2 years agoQrew Cadet
No Mark if the Book Id exists as part of another order then we have to flag the Book id record - "MultipleOrderExistsFlag" as "Y".
CustID1 Order1 BookId1
CustID1 Order2 BookId2
CustID2 Order1 BookId1
In the example above, the 1st and 3rd rows should have the field "MultipleOrderExistsFlag" as "Y".
------------------------------
Anitha Jeevarathinam
------------------------------