My FMP12 database has a table with many transactions identified by "name,budget". There is a monthly summary of charges sorted by this identifier. I'd like another table to keep track of the identifiers that have been used and add a new record when any new identifier.
What is the best way to compare the identifiers in a sub-summary with the table of identifiers?
thanks,
Glen
In the new table, I would set up Unique values, validate always on the key fields (or a text field with an auto-enter calculation that combines data from several fields if the uniqueness is based on the combination of values), then import from your current table into the new. The validation will omit duplicate values so this gives you a table of all current values. You can then use this table as a source of values for a value list or other value selection widgets. Set up your data entry so that values must be selected from this list and when a new value is needed, add it to this new table first and this should accomplish what you describe here.