Access to Sql Server Question 2 (1 Viewer)

[zezo2021]

Friends

I move the access to the backend SQL server
my problem is:
Multivalued field

How can I move the Multivalued field to the SQL server table?

I'm using access as the front end and SQL Server as backend

 

[cheekybuddha]

SQL Server does not understand a multi-valued field.

You will have to create a child table with the lookup values and another table to link the two (sometimes called a junction table) that has fields for the PK of the main table and the lookup value.

 

[zezo2021]

Thank you for the answer

 

[Auntiejack56]

There is a method for resolving this here: https://www.bluebridge.com.au/KnowledgeBaseMenu.html

There are multiple steps involved in setting it up, but it works for any number of different combos in your db that use an Access multi-select. There is a sample db to download that has all the code. Disclosure: I'm the director at BlueBridge.

 

[MajP]

Here is a free way to fake a MVF. As stated you have to make the junction table. I could not download the above demo, but this approach looks kind of similar. There is not much code required except you have to write the insert queries. I could not think of a generic way to do it.

Faking a Multi Value Field

I have seen a few posts lately on people wanting to use multi valued fields. Most Access developers steer away from them and build their own related tables. Although they are properly normalized and work well, they can get very confusing even if you know the ins and outs. I wanted to see if I...

www.access-programmers.co.uk