Hello group

I have not noticed a post on this subject, so here goes:

Situation: 2 tables
Problem: How to display an .asp page where a value from Table1 is replaced by the related value in Table2.

Example: Table1, Record1: company_id=5

Table2, Record5: Company_id=5, Name=Acme

Home.asp must display fields from Table1 but replaces "5" with "Acme" from Table2.

Hope this is clear?! Can this be done in UD without hand-coding? Perhaps in the SQL statement in "advanced"?

--------------------------
Skills: Visual
Non-skills: Code

Yes, the trick is to build clever SQL statements. Try finding some more information on how to use the JOIN feature in sql statements, they'll help you build wonderfull queries.

Waldo Smeets - www.UDzone.com Webmaster
------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
------------------------------------------