Hello,
I have to two tables, one with people and one with the orders that people have made. I have a form which is basically a pretty overview of some of the data in the people data in table form. I want to add a column that has all the unique values of a field, let's call it order type, in the orders table associated with each person, for example with the column names and an example entry:
first name: Harry
last name: Potter
orders_type: express; normal
Does anyone have an idea how I could accomplish this?
So far, I have only worked with macros and not modules, so I'd prefer solutions with macros.
Cheers,
Max
I have to two tables, one with people and one with the orders that people have made. I have a form which is basically a pretty overview of some of the data in the people data in table form. I want to add a column that has all the unique values of a field, let's call it order type, in the orders table associated with each person, for example with the column names and an example entry:
first name: Harry
last name: Potter
orders_type: express; normal
Does anyone have an idea how I could accomplish this?
So far, I have only worked with macros and not modules, so I'd prefer solutions with macros.
Cheers,
Max