"the expression is typed incorrectly or it is too complex " (1 Viewer)

[Design by Sue]

Rookie - You can't imagine my relief - I just hope that is the end of it.

Rain - See post #18 ( and one of my first posts also

Sue

 

[RainLover]

Sue

A List Box or a Combo Box should get its information from a separate Table.

This would be proper Normalisation because the current method has repeating data.

Storing in a separate Table means you only store that Table's Primary Key as a Foreign key in another table.

That is if I have read your post correctly which I believe I have.

Lets see if we can find someone to disagree.

 

[Design by Sue]

Rain - You statement is over my head (sorry - not that advanced I guess) Trying to explain, the information is based on a table with related information in another table. If queries can't link information from different related tables they would not be much use. I checked to see if I had, what I understand as, repeating data and I don't see what you are referring to. The fields in the query are all unique and the 2 tables used are related through the "Component".

Maybe someone else understands better and can concur or disagree.

Sue

 

[RainLover]

To move away from what you have lets look at an example.

If you wanted to find a Value via a Combo Box you would have a Lookup Table that holds that information and a Primary Key of Autonumber.

eg Colours

PK Colour
1 Red
2 Blue
3 Green
4 Yellow

Or Cities

1 Washington
2 London
3 Paris
4 Dublin

You query for the Row Source would be simply Select * From LookUpTable order by City

The Control Source would be the Field from the Forms Record Source where you want to store the Primary Key. You store the Key not the City or Colour.

If the Colour or City is not available then there is an Event that will allow you to write some Code to add the new Data. The Event is "On Not in List"

Hope this helps you to understand.

 

[RainLover]

A belated question.

Where are you getting the Data from.

 

[RainLover]

If you use the link in my signature it takes you to a site where you can download a sample on Not in List.

I may help you understand.

 

[RainLover]

I thought I was done.

Looking briefly at your Reports I notice that you use Combo Boxes. Combo Boxes will only work on Forms so don't use them in reports.