Jump to content

Structure problems


This topic is 2548 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 2548 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.