When you set up your radio buttons, is this what you have?
One field for Hispanic formatted with radio buttons to enter "RN" or "RC". Another field for Black formatted with radio buttons to enter "RN" or "RC" and so forth...
If so, should it be possible, say to select RN for Hispanic and RC for Black on the same record? If not, what steps have you taken to keep a user from making such multiple choices?
If so, then you need a calculation field that checks the value of all the ethnic fields to return RN if RN is selected and RC if RC is selected.
Case ( Not IsEmpty ( HispanicRNField & BlackRNfield ) ; "RN" ;
Not IsEmpty ( HispanicRCField & BlackRCfield ) ; "RC"
I've only used the Black and Hispanic fields from your example. In your solution, you'll combine all such ethnicity fields inside the parenthesis.
Alternative approach: it's possible, with a bit of trickery to make the above list a single radio button formatted field to help prevent users from making multiple selections.
okay If I make a field that does just this and later on down the road a group changes from RC to RN and I change the calculation will it recalculate all of the old records? I do not want it to change the old records. If it would is there a way I could do this?
How have you structured this in your tables? When you report on the gender/ethnicity of an owner, aren't you entering data in just one record for that owner? What "old records" would there be to update?
Yes, ethnicity and gender is entered for each company owner.
What i wanted was to place a layout where you could mark if a certain group was at this time RC (race onscious) or RN (race neutral).
For example Hispanic Males are currently RN and based off of there RN status the monies they make on a contract go into a field for RN monies. However next year they might not be RN anymore and we would have to change they're status to RC. When we change the status I don't want it to affect any of the contract we have been entering into the database over the last year and change where the monies were placed.
So is there is a way to make a layout with a field to put the status RC or RN of these groups that would apply to all of the companies that can be changed but will not effect the contracts that have already been placed into the database. Does this make sense?
In that case, you need a related table where each record represents a different ethnic group. That make for a simple two value radio button field for the RC and RN values.
Companies::Ethnicity = Ethnicity::Ethnicity
Any place you need to show the owner's ethnicity on a company layout, you can just add that radio button field from the Ethnicity table occurrence.
Since this is recorded in only one place, updating it changes the value you see throughout your databas automatically. This gets more complicated if you need to document multiple ethnicities for a single owner, but it still can be done here.
Okay I Made an additional table (PREFERENCES) and attached it to the (DBE_FIRM) table. I made ethnicy and gender = between the 2 tables and then placed the MODALITY (radio button for either RN or RC) field from the (PREFERENCES) table into the layout that shows records from the (DBE_FIRM) table.
It works in the (DBE_FIRM) table when a companies owners ethnicity and gender match what is in the (PREFERENCES) table it gives the radiobutton that was checked in the MODALITY field.
Issue I have a portal a layout that shows records from the JT_01_CONTRACTS_DBE_FIRM table (jointable). It works in bringing over the companies on the contracts and I have it bringing over the MODALITY (RN or RC) field that is in the (PREFERENCES) table.
My issue is that when I change the MODALITY field on the (PREFERENCE) table the companies listed on the portal for the contract change too. I need them to stay the same and only the DBE_FIRM records to change
Here is a picture of the relationships http://www.mediafire.com/?21h9zzodhy77w16
Let me know if you have some suggestions to making this work, thanks
I'm not quite sure why you need the markers for each contract for a given firm. Is this to show what was selected at the time the contract record was created?
If so, you'll need to add fields to the Contracts table that use looked up value settings to copy the RC RN value at the time the record is created.
The reason I need to know is because the RN or RC factor will be used to tell what pot the monies charged by that company will fall. If the rules change at a later date and a company that was RN is now RC I need it to place the monies in the RC pot but I don't want it to revert all of the old contracts.
That's what I suggested in my last post. Looked Up value settings can then capture this value at the time they are created. This is sorta like invoices where you don't want price changes to alter the data in previous invoices.
Okay I went into the (CONTRACTS) table and made a field called marker_rc_rn and made it a lookup from the (CONTRACTS) table to the (PREFERENCES) table MODALITY field and placed it into the portal. I'm getting nothing.
I checked the (DBE_FIRMS) table and the MODALITY field in it is correct with RC or RN based on the owners ethnicity and gender.
Am I doing the lookup incorrectly?
This will only work for new records. Create a new record and see if the correct value is looked up.
You'll need to use Relookup Field Contents or Replace Field Contents to update your existing records.
I did create a new record and still blank
I took a fresh look at your relationships. On further review, as they say, this field would be better off defined in the Join table to reduce the number of TO's between it and the "Markers" TO and to match the info in the contract to the correct linked DBE_Firm record.
That worked, thanks so much you got me out while I still have some hair left