I'm using SP2010 unfortunately without SP Designer and only used InfoPath once.
I have 2 lists:
List A - Is a list of 'Event Codes' with a 'status' column displaying Active, Used or Reserved status for each Event Code.
List B - Has a look up column displaying an Event Code from List A.
When adding a new item to List B and selecting an event code from the drop down box, I want to view all event codes and their allocated status next to each event code.
In effect having data from two columns displaying in the drop down menu.