Search results

Hi, I have a report that opens when opens should open an update query where the query searches for a filed Name like PNR and updates its YES/NO field to No where that field is yes by default I tried this in the criteria of the update query [Reports]![rptInvoice]![pnr] set the PRN fields...

I am guessing, if i have a table delivery report then i would need a Junction Table. Where this table would have DeliveryReportID,DelID_FK. So i have multiple inventory to agencies and want the delivery reports to be recorded in a table. So what i need is one Delivery report for several...

yes that is correct. Only one delivery at a time. So when would i need a many to many relationship or in other words a junction table

In my database that would be One agency would have several deliveries Can't figure how this relates in my database. Would it be like a reports table with several deliveries ?

Yes the agency name is unique as asiad above the update would fail if/when needed. I use the PK to link to the delivery table. ok so hat clears my doubts. Could you give me a many to many to relationship with respect to what i have. I understand the idea of many to many relationship but a...

Yes i do have it designed as said. but my concern is if its ok to see repeating entities of the of the foreign key from tblAgencies in tblDelivery ? Like there are numerous deliveries for one agency and that would create repeating foreign keys from the table tblAgencies in tblDelivery. Should a...

Hi, A little confused about the entities in the table. In my table tblDelivery i can several repeating entities from the table tblAgencies. One agency has several deliveries. So is it ok to see several agencies(entities) in the table tblDelivery or is it against normalization. Should i be...

hi, am a new to programming so bare with me please. :) I've been trying to create a search form and i see that the continuous form with text fields is the best way to go by. So in the After Update event i use the set filter for each text box [CustomerName]=[Forms]![frmSsssearch]![txtCustomer]...

Tried that just for that and the others also, but neither worked.

Thanks for the reply Doc ! but what does the extra ' do here ? treat that value as a string ?

That did not work. I've re-designed the query and the SQL string is SELECT tblDelivery.DelID, tblPCC.AgencyName, tblInventoryType.InventoryType, tblModel.Model, tblinventoryDetail.SerialNumber, tblCapex.Capex FROM tblCustomer INNER JOIN ((tblCapex INNER JOIN (tblModel INNER JOIN...

Will have a look at it.

Yea i was doing it all over again and it was the customer table that needs to be looked into.

Any luck ?

the file is here

Its the query qrysearch

I had send you my db. It should be clear

Hi, My query table is from another query. so does that preven some fields from displaying when using the criteria as [CODE[Like "*" forms!frmsearch!txtSerialNumber "*"[/CODE] one field works but when the next field criteria is added then the query result goes blank. So does the search...

Well that is quite simple and more understandable. what about multiple fields ? Thanks would this be possible in macro?

Yea there was one more table that had to be changed to NO :) missed that . now its ok. Now does anyone know how create search form such that the records are filtered as they are typed in the form fields. I know its possible with vba was hoping to learn it through macro, if there is a way