G
GoDawgs
I'm working on a contracting database where the root record is a contract,
there is a linked "mods" table (child) for each modification of the contract.
There is a funding source table (each mod may be funded by different or
multiple parties) linked (child) to the Mods Table. Also linked (child) to
the Mods table is a Reasons table that stores the reasons for that mod (time
extension, increase in total funding, change in funding officer, etc). There
are often several reasons for a Mod. Currently, I have a button on the Mods
form that opens a Reasons form where the user can add as many rows (reasons)
as they need to for the mod.
I'm trying to change the user interface to add radio buttons directly on the
Mod Form where they can select all that apply and then based on the ones
selected populate the reasons table for that mod. For example, if the radio
button labeled "time extension" is selected, "time extension" is inserted
into the reasons table for that mod
Any suggestions on how to do this would be appreciated.
there is a linked "mods" table (child) for each modification of the contract.
There is a funding source table (each mod may be funded by different or
multiple parties) linked (child) to the Mods Table. Also linked (child) to
the Mods table is a Reasons table that stores the reasons for that mod (time
extension, increase in total funding, change in funding officer, etc). There
are often several reasons for a Mod. Currently, I have a button on the Mods
form that opens a Reasons form where the user can add as many rows (reasons)
as they need to for the mod.
I'm trying to change the user interface to add radio buttons directly on the
Mod Form where they can select all that apply and then based on the ones
selected populate the reasons table for that mod. For example, if the radio
button labeled "time extension" is selected, "time extension" is inserted
into the reasons table for that mod
Any suggestions on how to do this would be appreciated.