The football data is simply a mock of two tables transferring data. I have been presented with the actual data in numerical values in the initial table but wish to produce an itemised listing of the information stored within table one. The raw data arrives from an external source electronically...
I have a simple data base, which I want to use the data is one table to populate information in the second table.
Table one is a list of values indicating the amount of goals scored. Table two shows the teams that an individual scored against, I want this to self populate based on the team name...