1 form for multipl identicle tables

[blizma]

Is this possible? its for my coursework.
The tables are exactly the same, just with different info on it.

I tried doing something with the relationship, but i didnot understand that.

REALLY apretiate any response.

 

[boblarson]

While trying to maintain the integrity of your course, I'm going to give you a hint and will expect you to go investigate and try to figure it out on your own.

The hint is Recordsource

 

[Bat17]

I would also hint Normalization
If you have multiple tables with the same structure then they should all be combined with a field added to allow filtering

Peter