What exactly do you mean about the table design?

The form in the access it boiund to a query that is actually a joined query of 2 tables??

I'm sorry if I am unsure of your question