Link Table

[smilingjohn]

HI Expertise ...

Iam trying to create a Link table  it works for 2 fields .. and when i try to add more than  2 fields it gives me an error.

as shown in the attachment.

Is there any rule where  that only two fields can be created as link table ?

What if want to add Autonumber( for 4 fileds ) ?

How do i approach this ?

And also is there any way that i build a pplication and give it to a user and he ipens on his desktop ...aand he cannot reload the file nor can make any changes to the charts  and cannot dleete any of the charts on UI.. Is this possible ?

[orguezfaccsa]

Hi,

    I can't see any attachment

Best regards

[smilingjohn]

Hi Oscar .. I have resolved the first  question ..If i want to add more than 2 fields then i have to use

Autonumber128( class,Student,Subject) as School,

Can you please answer my question..and it will be really helpfull if you can give me it with an example

[orguezfaccsa]

Hi John,

     when I've two or more fields, I concatenate them in a string and I use it as primary key. This way allows you to simplify connections between tables.

[orguezfaccsa]

‌Hi John,

    What do you don't understand? I see two tables, what is the problem?

[smilingjohn]

Hi Oscar as you mentioned i have resolved the answer ..

I wanted to know about my second question ...

Is there a way to create a QVw file which cannot be reloaded nor can be the charts deleted from it

[sudeepkm]

Maybe you can ask users to download the QVW from AccessPoint in that case the script will be unavailable to reload and you can make the properties of the objects not to be altered using document > sheet > security and doc properties > security settings.