I have a notional form that shows a list of fruits, as a drop down list. The user chooses the fruit from the list, presses the submit button and a list of all the users that like that fruit is displayed.
Example tables:
Fruit Table:
ID (PK) /Fruit
1 Apple
2 Orange
3 Bananas
4 Grapes
People table
peopleID / People Name / FruitId
1(PK) Jo Soap = 1 (FK) (apple)
2 Bill bags = 2 (orange)
3 tom jones = 2 (orange)
There is a 1 (fruit) to Many (People) link between the tables
And it works - after a fashion. So if someone picks apples from the list all those users who like apples are displayed. The problem is where someone, say, picks Orange (in this case) and there are more than one people who like Orange.
Ideal display…
Fruit:
Orange
People:
Bill Bags
Tom Jones
Actual Display:
Bill Bags Orange
Tom Jones Orange
How can I stop the Fruits name from showing all the time?