Using two tables to run a contacts and comments

[Greg]

I have two tables, customers and comments and I'd like to have the comments for each customer stored in the comments table, displayed on the resulting page for each customer. I'm just a little lost as to how to accomplish this and don't know if DaDaBik can provide this or not?

Customer Table
CustID
Name
Phone
Email

Comment Table
ComID
CustID
ComDate
Comment

Am I not able to accomplish this at all or am I just missing the most basic thing? Any step-by-steps offered would be greatly appreciated.

Greg

 

[Eugenio]

Greg wrote:

> I have two tables, customers and comments and I'd like to
> have the comments for each customer stored in the comments
> table, displayed on the resulting page for each customer. I'm
> just a little lost as to how to accomplish this and don't know
> if DaDaBik can provide this or not?
>
> Customer Table
> CustID
> Name
> Phone
> Email
>
> Comment Table
> ComID
> CustID
> ComDate
> Comment
>
> Am I not able to accomplish this at all or am I just missing
> the most basic thing? Any step-by-steps offered would be
> greatly appreciated.

If you want, when I user click on a customer edit/details button, show all the comments linked to that user as results table the answer is no, it isn't possible.



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