AnsweredAssumed Answered

Trying to make something like a marker that will not update old records

Question asked by kilbot on Mar 8, 2011
Latest reply on Mar 11, 2011 by philmodjunk

Title

Trying to make something like a marker that will not update old records

Post

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

Outcomes