Simple Database design issue

[MartinN]

This is the simplifying I'm trying to accomplish:

I have a table called Past and another table called Current.
Both have a number of attributes that are unique to their respective table's,
but they both have an attribute called Allergies with other attributes that are associated with the Allergies attribute.
My question is: If I were to create a table called Allergies and put the associated Allergies attributes in it,
how am I to know which table this record belongs to? Past or Current?

Thanks, Martin

[JeffB]

You could have two table Past_Allergies and Current_Allergies, but the best would be to add a field in your Allergies table (could be a boolean value or a short) to hold whether true/false or 1/2 (or any two values you think are appropriate)

JeffB