Relate 2 database with Projects ID

[albertomichieli]

I have these 2 files connect like relational

there is a field called protocol in the Project Tasks (PT) layout Note, that I want to link to Projects (P)

you can see I connect them in the view Note Layout

[if ask for other file do not need to open just cancel]

the thing I cannot do is to put more option of the protocol field or add more Projects to a Project Tasks

like 3-4 different

for example

a field about movie 0056 can be connect to politics 0042 or internet 0044

Any solution?

DMAProjects.zip

[Jeff Bills]

I was only able to find it in the layout, "Form View".

Is this correct?

[albertomichieli]

Correct.

there is field Project name [P] and Project Task [PT]

I want to link them.

For example a website of t-shirt [inside PT] can be part of many [P]

[Jeff Bills]

If you don't mind the aesthetics, change the field from a drop-down list to a Pop-up menu. Then hold down the shift key and you'll be able to select more than one option

[albertomichieli]

I tried but it does not acept more than 1 entry

[Jeff Bills]

Try this.

I highlighted the protocol field in blue. Choose extras while holding down the shift key and you can view them in the expanded field (just for fun)

1155395343-DMAProjects-2.zip

[albertomichieli]

Ok. I got.

But my question was also that when I open the Projects file, I actually see the new Project Tasks field associated.

[albertomichieli]

see new picture png

[albertomichieli]

here

[Jeff Bills]

Hi,

It would help me if you could explain what you're trying to accomplish. I see you have project ID and manager fields and that each project has one or more project tasks but to what end?

For starters, unless there's a NEED for multiple files, you might want to consider using FM7's multiple tables capability and merge both files into one document as it tends to be easier to manage.

Are you wanting the (multiple) results from the protocol field to show in each line of the Project tasks portal in the PROJECT file?

Looking forward to hearing from you

[albertomichieli]

I want when I make the link in the protocol to make association between different [P]

for example a [P] has many [PT], one of this is to have info about printer

the same [PT] can be associated to another [P].

Currently I copy the information into another [PT[ of a different [P], instead I want to link it

I prefer to keep the same situation like now, separate files

[Jeff Bills]

I think what you want to do is beyond me. Hopefully someone else can take a stab at this for you

[albertomichieli]

Ok Thanks

[T-Square]

What you want is to have a many to many link--in other words a given P can have many PTs, and any PT can have multiple Ps. This requires a 'join table' and a portal. The join table will have fields for the ID fields of each table, and needs nothing else (although other fields can be added). Users select a PT from a drop down value list based on the PT table.

HTH,

David