Jump to content
  • 0

connect Article reference nr. to virtual field Description


vdb@telenet.be

Question

Hello,

I have a website where i sell products.

I have approx. 40 fields in the Ordertable to put in the products (wich are choosen trough drop-down lists and puts only the ref.nr. of the product as reference(field for value).

I cannot put in the Article description, because the MS Access table import does not allow that much value to import (using the SOAP plug-in from Caspio).

The problem is that i can only show Rer.nrs. of the article in a shopping-basket view on the website.

I also tryed different ways with Caspio Views, but it does'nt work...

I would like a kind of Virtual field that i can use to display the article description related to the Article Ref.Nr.

Can someone help me with this?

Thanx

Bart

Link to comment
Share on other sites

5 answers to this question

Recommended Posts

  • 0

Hello,

thank you for the answers.

CSV is not automatic (automation).

Bahar,

I have different fields in the ordertable like: FishChoice1, Fishchoice 2, Meatchoice1, meatchoice2...

and then i have a lookup table TblArticles wich i use in the dropdown to fill-in the choices (meatchoice1 etc...) and i can not set the description of the article as "field of value" because MS Access does'nt allow so much info coming in trough a soap connection per table...

But i can't create a view of this... (combined the TblOrders and TblArticles).

Is'nt there a way to do this?

Greetz,

Bart

Link to comment
Share on other sites

  • 0

Hi Bart,

You need to have the tblarticles which includes the product ref number and the product description inside Caspio. So you will have the tblOrders which includes the product ref numbers and tblarticle which includes the descriptions. Then create a View to join these two tables inside Caspio on the ref number field and use this View for your reports to display the description rather than the ref number.

If this does not answer your question please explain your project and its relation to Access as I am not sure why Access limitation is related to this case, I read the original post and your last comment couple times but still does not understand what Access plug-in has to do with making Caspio View?

Best,

Bahar M.

Link to comment
Share on other sites

  • 0

Hello Bahar,

it is still not possible because you have multiple fields(products refs.) in the order tabel, and only one Ref. field in the Article table..

Maybe it is better that you can see it for yourself on my account.

You have the permission to enter it from me, the username is bartus.

In Views you can see 2 views, one with 1 ref. nr connected, wich works, and the other view with multiple connections (2) wich don't work..

Thanx,

Bart

ps. the relation to Access is that the amount of text(data) per row is to big to import trough a soap connection in a access table. The problem is not the table limitation,, but the row limitation. Because i can query the article export file with ref.nr and description(agregate in access query) and use this in the lookup dropdown(in caspio), but afterwards i can not import it anymore in access(the orders).

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...