Copy data in fields to other layout via script
We have a Radio log layout that boating members sign on to when they go out (fields like: vessel_reg, vessel_name, position, mobile phone, people on board, (overnight which is a value list of Yes and No) etc), each log is a new entry, we also have an overnight log (fields: vessel_reg, frequency, position, people on board, (cleared which is a value list of Yes and No) if they are staying out overnight. All in the same database.
What i need help with is this if a vessel is staying out overnight and the overnight drop down box = Yes i need the data that is entered in the fields in the Radio Log: frequency, vessel_reg, people on board, position, mobile phone and cleared fields to be entered in the overnight log.
Hope this makes sense.
We are using FMP Pro 11 with Win XP service Pk 3.