sql server 2008 - Create a single Query By Form for multiple tables -
i want create query form access database has linked tables sql server database. database has 30 tables , want create single form query data tables. unable figure out how started.
in form design, @ property sheet , make sure "form" selected in dropdown. - @ "data" tab, , "record source" area. click in there , click "..." button. should able choose multiple tables , define joins, , use form values part of criteria.
Comments
Post a Comment