AnsweredAssumed Answered

Relationship

Question asked by KatNicole on May 26, 2015
Latest reply on May 31, 2015 by philmodjunk

Title

Relationship

Post

I would just like to ask how to successfully connect one field with the other successfully.

I have a table - GC Master List which contains the pertinent identifiers of gift certificates and to each addition to the list, the system generates a control number for it.

I have another table - GC Transactions where only GCs existing from the master list are accepted to transact, I would like to ask how I will be able to show the automatically generated control # in a field in this layout once a user encodes in a valid serial number?

Also, how to automatically reset the the control number  series back to "0" every day because my control number consists of the current date converted into numbers and a 000 series that is incremental by 1 for every record committed.

Hope you guys can help as I am really new to developing filemaker solutions. Thank you.


smiley

Outcomes