Access 2010

[rudy78]

I've installed access 2010. But now i cant set relation ships, (it's grayed out). Any chance i can find some help on the internet?

 

[SOS]

Do you have tables in your database?

 

[Banana]

Did you create a web database? If so, then you can't use relationship as you could do in a regular database. If you've created a regular database, then we'll need more info.

 

[SOS]

Did you create a web database? If so, then you can't use relationship as you could do in a regular database. If you've created a regular database, then we'll need more info.

Ah, good point. I hadn't thought of that possibility. Web databases are going to be different as the relationships are defined on SharePoint (am I correct Banana?).

 

[Banana]

Well, I suppose so.

Strictly speaking, Sharepoint is not a relational database. Mind, it has many uses and it may be powered by SQL Server, but the lists themselves are not relational. Now, at least they did make it so that Sharepoint 2010 supports referential integrity & cascade deletes, presumably by doing some magic behind the scene so from a end user's POV, it's still the same thing as how we've defined ways in Access.

Relationships on Sharepoint are defined by Lookup fields only, BTW.

 

[rudy78]

thanks, i did manage to relate by using lookup fields. thanks again!