Datavase Joins in Detailed Results

[Master Burnett]

Please forgive me if this question is too basic, I am not that technical.

I am trying to build a tracking application using DaDaBIK that will allow users to enter into the details of an order once shipping has been arranged. Customers will then use a web based form to search using their order number to find out what carrier the product was shipped on, the shipping date, carrier tracking URL and tracking number.

I have created four tables:
OrderDetails
CarrierDetails
DestinationCountry
CustomsAgents

In order details I have created it so that the sales rep can select a destination country, carrier, and customs agent from drop down select menu's.

I would like to add several fields to the details form that the customer sees after executing a search based on what the sales rep selects from the drop downs. Example, when the sales rep selects "United" from the carrier drop down, I would like the details for this record to include the field HomePageURL from the CarrierDetails table.

How do I do this?

Sincere thanks for you help.

Master

 

[Eugenio]

Master Burnett wrote:

> Please forgive me if this question is too basic, I am not
> that technical.
>
> I am trying to build a tracking application using DaDaBIK
> that will allow users to enter into the details of an order
> once shipping has been arranged. Customers will then use a web
> based form to search using their order number to find out what
> carrier the product was shipped on, the shipping date, carrier
> tracking URL and tracking number.
>
> I have created four tables:
> OrderDetails
> CarrierDetails
> DestinationCountry
> CustomsAgents
>
> In order details I have created it so that the sales rep can
> select a destination country, carrier, and customs agent from
> drop down select menu's.
>
> I would like to add several fields to the details form that
> the customer sees after executing a search based on what the
> sales rep selects from the drop downs. Example, when the sales
> rep selects "United" from the carrier drop down, I would like
> the details for this record to include the field HomePageURL
> from the CarrierDetails table.
>
> How do I do this?

I don't know if I have understand the problem....do you want to change the number of fields displayed in a detail page according to the search parameters?
It isn't possible.



(Latest version of DaDaBIK when this message was posted: 3.0 beta)