Discussions

 View Only
  • 1.  Are there any sample apps that use DoQuery to populate fields from another table.

    Posted 10-01-2018 09:58
    I can't use relationships here.
    Are there any sample apps that use DoQuery to populate fields from another table.

    I know a champion has responded to a similar question but by copying what they suggested I still got an error, the online demo's don't give you access to the properties so there could be something amiss there.  The demo was the one based around the tables Records and Ipsums.
    It would be helpful to be able to download an app with something working so I could copy it from there.


  • 2.  RE: Are there any sample apps that use DoQuery to populate fields from another table.

    Posted 10-01-2018 14:20
    Any specific reasons why: a) No relationships and b) Only DoQuery?


  • 3.  RE: Are there any sample apps that use DoQuery to populate fields from another table.

    Posted 10-01-2018 14:40
    yes, I'm working on a quote system with would either swarm the reference table with relationships or swarm the database with tables, having a single reference table is the sensible option but I'll need to get my head around doquery, I've got as far as I can with the code, but would like to see a working example to see what I've got wrong.  The Records and Ipsums example looks good but I can't access the properties, so any application with a working doquery would be great.