Populating a container field via calculation

[snewcom]

I am attempting to populate a container in file "Orders" with the contents of a container field located in either "Graphics" or "Logos". "Logos" contains the logo of individual vendors in up to six different colors. Keyword in "Logos" is Vendor #. "Graphics" is almost identical in that each record contains 1 graphic in 6 different colors. Keyword is Graphic #.

Each Order record will have the following relevant fields:

Text Color

Vendor # - Keyword related to Logo File

Graphic # = Keyword related to Graphics File

Here is what I want to happen:

1. Place the correct color graphic from the Logo file into Order "Graphics Container" field based on Order File "Text Color" field, ie. If text = "Black" then place the "Black" logo into the Orders container field, etc for each matching color. (I am assuming a case statement)

2. If Orders contains a value in "Graphics #" field than place the correct color graphic from the appropriate Graphics file into the Order "Graphics Container" field based on Order File "Text Color" field. (Again, I assume a case statement). If the Order File contains both a Vendor # and a Graphics #, the Graphics # trumps and should be placed in the Orders Graphic Container.

3. Finally during the printing step, I need FileMaker to determine if there is anything in the Orders Graphic Container Field. If yes then go to layout A, if no go to layout B.

I expect this is pretty straightforward but I haven't done much new coding since I created this solution back in FileMaker 7 days. Your help is really appreciated.