Multiple use of a table within a single form

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

Hi.

See if this makes sense to anyone.

I'm trying to figure out a way to use the same table
twice within a form. I'm creating a database to track
sporting events (Rugby Union Super 12 in this case). My
first, an easiest way so far, is to duplicate the table
into home and away. For aggregate totals I use a query
against the home table and the away table using the team
name as the key field. This works well enough but I'm
sure there must be a better way. The points scored are
already a sub-form to a 3rd table with a key field using
the autonumber of another table called game.

Thoughts anyone?

Thanks,

Matt
 
Based on the information given, I would advise one table
with the following columns
gameId
home team
away team
home score
away score

Hope That Helps
Gerald Stanley MCSD
 
Back
Top