hi all
before I redesign my DB i would like to ask you if it is possible to create a relation between table ie "elementary" where I did create two look-up field from child table "group"
"elementary" can belong to many groups in my case currently max two
is there a way to create relation between those two tables connecting two look-up fields from "elementary" with idgroup (primary key) from "group" table

thanks

Table level lookups are a nightmare. The best way to implement a lookup is in a form via combo box or a list box where you have much more control over the behaviour.

does anyone then have an idea how can two fields from child table in parent table could be connected
I have:
Table "Element"
elementid
group1 (now look-up with groupid)
group2 (now look-up with groupid)

Table "Group"
groupid
name

thanks

You are working in the tables.
You cannot do what you want there.
Tables are to store data. Forms are to interact with the data.

Make forms. You can connect two fields in forms.

DO NOT USE LOOKUP FIELDS IN TABLES.
They can be included up until you design the forms because the Wizard will automatically make combos on the form to match. Then delete them.

Hard to say with so little information but I suspect your structure may not be optimal. Post a brief description of your project.

my only problem here is simplicity
i am doing this for my illiterate coworkers and they choose tables as they are more familiar with excel "look"
in any case redesign is necessary
and I will try to make simple and user friendly forms