I've got a layout I use to create (and print out) checks. It's simply a layout with a series of edit boxes and a portal on it. One of the edit boxes on this "checks" layout provides the amount. The whole layout works great, but I've got one little problem.
I want the layout to generate a record...
I think I want to use the Set Field script step. Here is what I want to do. It's really very simple.
I've got table [Join], which has the following fields:
[WellId]
[OwnerId]
[InterestId]
[InterestType]
[ProductionMonth]
[Year]
In a related table, [Owners], are the following fields:
[GasPrice]...
How do I do this simple thing? I want to have a table [Months] with two fields and 12 records, one field as [MonthId], and another filed as [Month].
There are twelve months of the year. I simply want to create a value list from the table, but Filemaker won't let me NOT create a 13th record...
Here is my relationship diagram.
My problem is that I can't add records to fields whose relationships are set to allow records to be added to the "many" side only, but not to the one side.
All of the relationships in the database are set up so that records can be added to tables on both sides...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.