query to flash out similar ids

[warriorX]

i am a newbie to access, so please keep your reply simple. situation:
i have two tables 1 for mother and the other for child, ID patarn for mother = 1000m and for child 1000c i want to create a query which will show the mothers
details alongside child?

[NeoPa]

Have you given this any thought?

You tell us so little it's barely a question at all, yet what you tell us doesn't seem to make sense. In a normal mother / child relationship it is possible to have multiple children for each mother. If the ID for the mother is 1000m then only one child can have an ID of 1000c.

What is more usual in such situations is for the child to have a [Mother] attribute wherein would be stored the reference to the ID of the mother. This way you could even maintain the data in a single table and the mother could (& would) have a mother of her own. You would not have a different format for the child as opposed to the mother. Each ID would relate to a person, and the [Mother] attribute would define the relationship.

I hope this is some help. If not, you may want to consider asking the question more clearly. That doesn't require Access skills after all.