Search results

Thanks so much - I will thoroughly review this info. However, I have to say that as I've searched the web for more info on multivalued fields, I'm now thinking that I need to press for removing them from the db and replacing them with another table or additional fields in the Master Table. This...

Hi! Like it or not, I have a form with (among others) a Y/N field and a multivalued field. The Y/N field indicates whether or not the resident is year-round or not (seasonal/snowbird). The multivalued field contains the months the resident it here. The user wants me to auto-select all months in...

Thanks so much. Your reply pointed me in the right direction. I was using a form to enter the data but I had incorrectly established Lookups on both the Table and the Form. Anyway, everythingi s fixed and working now. I really appreciated your prompt reply!

This is my 1st post so hope I do it right... I have a Master Table where fields are populated using a drop down box that is based on a Table with 2 fields: ID and Day of the Week. When I query the Master Table and use the parameter [Enter Day of Week], the query only works if I enter the ID...