Try a separate table to hold the signature and its user name in a single record—two fields, any number of records. Then set up a relationship between this table and the table in which the signature needs to be used.
Or try repeating fields.
i think i will try to avoid repeating fields. cause i will be using calculations on the fields
#1 you can do calcs on repeaters
#2 any time you have the urge to name a field with a numeric indicator i.e sign1, sign2 etc or think you need a repeater you should stop and read up on normalization and data modeling.
IMHO the images should be stored in the Signs out table.
thanks for your advice i read STOP and reconsider.
sorry for the extra message, I wanted to fix my note:
I promise I'm not self-promoting (in this case), but if you have FM14 or 15, please look at my puzzle project:
I'm not using repeating calculation fields, but I do use repeating container fields in a novel way.
For repeating calculation fields, you can use Get(CalculationRepetitionNumber) to know which one you're working on.
i am having so much problem referring the repeating fields to each other, ie. when sign is signed, sign_date put the date in
You might be needing Script Triggers, and therefore Get(ActiveFieldRepetition).
This is how my puzzle (see above) works - click on a tile, a script trigger fires the script "Click".
Is anything easy?
well i see, i know how to set the date with a trigger. But i have no idea how i can set the sign_name field with a lookup that uses the Get(account name) to look up in the staff table.
i am very sorry about the mess i am causing
if you use the Account name, you'll need one account per user. You probably knew that.
Now, if you have a Staff table with a key that matches each Account (the ones in Security), then here's one possible way to get data from the staff table:
Use the ExecuteSQL function. Set your sign_name field with something like this:
"SELECT Name FROM Staff WHERE StaffAccountNameKey = ?";
thanks so much , you are my hero. never used sql before but i suppose its about time to learn i