Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › DA SEARCH Query

DA SEARCH Query

Thread began 9/29/2010 7:10 am by Cologne | Last modified 10/07/2010 11:42 am by Cologne | 4110 views | 22 replies

10/01/2010 11:20 amCologne

Hi Jason,

I cant store the InstrumentID and GenreID in the Profile table, cause I stored all instruments and genres in an extra table, so no instrument or genre is double.

What I did is...

I created an table called profileInstruments and profileGenre that stores only the foreignkeys (InstrumentID / ProfileID and GenreID / ProfileID)

I my searchform I created 2 lists, from profileInstruments and profileGenre, so I got all instruments and genres that are available.

No my problem is, to unit all there 5 tables to get a search result with DA-Search.

Genre, Instrument, Profile, ProfileInstruments and ProfileGenre

I dont know how to crate, that recordset, so I can make a search.

Denis

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.