Fill table control from a two tables?

Creating and using forms
Post Reply
gosha
Posts: 1
Joined: Tue Apr 15, 2008 9:41 pm

Fill table control from a two tables?

Post by gosha »

Hi,

I have two tables:

Services and ServicesToClients
ServiceID ServiceID
Description1 ClientID
BasePrice Description2
Price

I have a form with clients data (another table called Clients) and subform (table control) that should edit the services list for current client with the following fields:

SevicesToClients.ID,
SevicesToClients.ServiceID (combo-box, filled from Services table),
Services.Description1 (read only, should be filled from table Services and depended on current selection in ServiceID combobox)
Services.BasePrice (read only, should be filled from table Services and depended on current selection in ServiceID combobox)
SevicesToClients.Description2
SevicesToClients.Price



What is the simplest way to create this?
Post Reply