Structure problems

[Filip Langenbick]

Hello,

 

I've a difficult problem.

I have serval linked bases

BASE 1 = Planning (red)

intermediate base Planning_Objects (dark green)

BASE 2 = Objects (blue)

intermediate base Object_Contacts (pale green)

BASE 3 = Contacts (mauve)

The 3 base are linked together as follow:

 

BASE1 ---> intermediate base (relation = id_planning <> id_objet) ---> BASE2 ---> intermediate base (relation= id_object <> id_contact) ---> BASE3

 

For some reason i need a field (or to create a record) that unique between base 1 and base 2.

One date = one contact.

How could i do this without changing my structure?

 

Thanks a lot for helping me if possible.

 

Filip Langenbick

fm.tiff

[Steve Martino]

I'm completely confused.  A first question might be, what does (or what do you want) your database to do? A better description of workflow and data may get some responses.

Are all of these TO's with the word 'planning' in them all from the same base table?

It's probably likely you will have to change some structure.  It's important to make it correct now, or possibly suffer dire consequences down the road.

3 hours ago, Filip Langenbick said:

For some reason i need a field (or to create a record) that unique between base 1 and base 2.

What would be the reason?

[Filip Langenbick]

11 hours ago, Steve Martino said:

I'm completely confused.  A first question might be, what does (or what do you want) your database to do? A better description of workflow and data may get some responses.

Are all of these TO's with the word 'planning' in them all from the same base table?

It's probably likely you will have to change some structure.  It's important to make it correct now, or possibly suffer dire consequences down the road.

What would be the reason?

Hi Steve,

Thank for your reply.

My database is for an event organisation.

It's has on 3 bases (see image fm3):

1. Planning
   1. ID_Planning
   2. Date
   3. Hour
   4. ...
2. Object
   1. ID_Object
   2. a taks
   3. a spectacle
3. Contact
   1. ID_Contact
   2. name
   3. email

The intermediate bases are linking the bases together by a simple relation.

Intermediate between planning and object will link the ID_Planning with the ID_Object

Intermediate between object and contact will link the ID_Object with the ID_Contact

 

EX. 

DATE1 has planned OBJECT1 and OBJECT1 had 3 people attached to it (see image fm1)

 

Now what is my problem:

In the planning base i created a field named "Bottleneck".

The purpose is to highlight a Bottleneck in the planning of a person.

I created in the Contact base a portal tool to see all planning per person (see image fm2)

When i highlight the "bottleneck" field (red x) the problem is that it will highlight for every person that is linked to the object and i would like to be able to highlight it for only one person.

Does this makes more sense?

Thanks,

Filip

 

 

 

 

fm1.tiff

fm2.tiff

fm3.tiff

[bruceR]

Note that JPG and PNG files will display in line here.