I have 2 databases running in parallel - one contains every cow I’ve ever owned, and the other contains the cows still alive and in production (a subset of the first database). Many of the fields in the 2 databases are different, but a few core fields are the same. Because I want to be able to select and sort these fields in either of the databases, I felt that using the lookup function to display the information between databases wouldn’t be practical. Therefore, I am trying to set up field property code, to post changes made in one database to the same field in the other database.
This is my code:
post "updatesave" ,"Cattle Database-Active 3","Unique",Unique,"Prefix",Prefix
When I have this in the code section of the Field Properties panel, I get an error message saying “Missing parameter in Post.” When I put the same text into a procedure through the menu, it runs, but is changing a record either side of the one that should (I thought) have been the matching record.
I don’t understand what is happening in either case. Any help/suggestions?