Trying to make something like a marker that will not update old records
Hopefully this makes sense
I have a table that containes a lot of companies and their info.(working and loaded). In this table it list the gender and ethnicity of the business owner.
I want to have another layout with the minorities/gender that we look at listed like Black, Hispanic, Asian Pacific, women....
I would like to make a radio button set next to each minority for RC (race conscious) and RN (race neutral). I know how to do this.
Hispanic o RN o RC
Black o RN o RC
When RN or RC is checked in the layout above I want in a marker field in the table of companies, based on the company owners ethnicity to show either RN or RC for that company.
Can I do this? do I need it to be in a separate table? Will when the RN or RC is changed for a minority status changed only change for the new records created? I do not want the old records to change when the minority status changes.
Thanks for all those that can understand my polluted thoughts