Hi all,
2Tables: PlotsForm (connected to ‘plots’ table) and PlotForm (‘plot’ table)
2Controls: PlotsTbl (PlotsForm) and PlotIDField (PlotForm)
‘plots’ table holds info + plot_id (pk) for each plot.
When I change records in the PlotsTbl control I want the value in the plots.plant_id column column to be copied to the first record of the only column in the table plot.plot_id.
Every-time I choose a new plot from the PlotsTbl control the first and only record in the PlotIDField should be changed so that queries can reference it and be able to see which is the currently selected plot_id and when I go to create a report it will create it based on the value in plot.plot_id.
Here is the database in dropbox in case that helps:
https://www.dropbox.com/scl/fo/wmbtn6o89ixk7swpet0e3/AAPw9J4s8nf0k6qAbeGdAMQ?rlkey=6s4holdg9jzsoanjj9yw5fn0e&st=coym4kbb&dl=0