Search results for query: *

What mean the A? I don't have any table called A Thanks

My Form link table name is Sale My Fix list table name is t_Asset The record in t_Asset called r_Asset

I don't understand from where it will taken the list and what is the 'FixName' and 'A'

I need to create Fix List in ComboBox on Form. I need the select data from the Fix List will be stored in the connected table to the Form. How to create this Fix List? Thanks in advanced

This solve half of the problem the master table with the lookup to the ID in the data is also not update and this table I want to update.

I'm creating form with combo box which is lookup to data list in table (this table need to stay as is without changes, the data is corresponding to other table by ID field) when I'm choosing one value in this combo box this value is duplicat it salf in this table. How can I prevent this...

I'm creating form with combo box which is lookup to data list in table (this table need to stay as is without changes, the data is corresponding to other table by ID field) when I'm choosing one value in this combo box this value is duplicat it salf in this table. How can I prevent this...

I'm updating the query with form.

For example the table t_Asset is need to be constant but the record t_Asset.r_Asset is updateing each time I have updating the Sale table thru the query. How can I change it to not updateable. Thanks in advanced.

Here is my SQL SELECT Sale.[Family Name], Sale.[First Name], Sale.[Home Phone], Sale.[Cell Phone], Sale.[2nd Cell Phone], Sale.[Work Phone], Sale.ID, t_Asset.r_Asset, Sale.Rooms, t_City.r_City, Sale.Neighborhood, Sale.Street, Sale.[Build Number], Sale.Apartment, Sale.Price, Sale.[Old Price]...

I'm not must to work with form, it is also happend with my query. please help to get the queries sql and I'll paste it

All these are good but not solve my problem: I'm trying to make relationship between two (and more) tables for query. I need to read from one table the data but not write to it. The ID row will be linked to the other table (this table will be update with the number of the ID). Until now I...

I'm not opening it from Form it is query I'm trying to make relationship between two (and more) tables for query. I need to read from one table the data but not write to it. The ID row will be linked to the other table (this table will be update with the number of the ID). Until now I have...

I want to create table with constant data and query that just read from it but not update. How can I promising that the constant table will be not updates from this query? Thanks in advanced