Search results

I’m really sorry, please bear with me. 😀 I’m going to go away and read through this thread again, thoroughly. As it stands my 2nd table does have the number stored in it which I believe is the PK of the customer table. Were you able to view the relationship pic? It’s the part where you suggest...

Ok. I think i understand. Here is a copy of my relationships; https://www.dropbox.com/s/dh7dkpc2w7zabha/Annotation%202019-06-25%20120040.JPG?dl=0 So I should just have all of my fields in all of my tables as text etc and avoid the lookup option. Then when I need to refer to a list of say...

Ok, well that would explain why I've been having a nightmare time later down the line creating searches etc Thank you for the 'Here's some reasons why', I don't suppose you have a link to 'How to change lookup fields in a table back to short text fields' :) I suppose i can do this but first I...

It looks like I've figured out what was wrong. I didn't have the field I needed in the Row Source. So i edited to include it and then picked the correct Bound Column. I say figured out, I Googled what a bound column really means! Hi, the DBguy, I used the LookUp wizard when i created the table...

Hello, I have a table of customers with simple short text fields throughout. I have then created another table where I refer to the customer table in a combo box. I used the lookup option when creating the table which then led me off to choose the customer table and sort the names etc. So in my...

Thanks Plog. I needed it spelling out. I understand now. Thanks all.

Ahh, so I should put that expression into a query instead of the control source of the field on the form? When i did that before i couldn't get it to update the field. Can you point me in the right direction? The plan is to add a record, choose a support type, pick a date and then my reference...

Sorry, I think it's the way I've worded it. I don't want to put a calculation in the table. I just thought that if i put the expression into my form in a new field [ReferenceNo] then the answer would also save into my table. But i can see that it doesn't. I suppose it doesn't matter as long as...

TheDBguy, that’s right all those are in the same table. The expression is just on a form which gives me what I want. This leaves the field in the table empty - is that right? I thought the answer to the expression would fill in the field in the same table. The_Doc_Man, I tried that but couldn’t...

I could do with a brew now. I'll pop the kettle on :)

Ok, so this is my first post - hopefully I'm in the right place. My DB form is for logging support emails. I have a primary key 1,2,3 etc and also a field where I want a reference to the support i.e. 2019-1-R The 2019 is the date, 1 is the primary key and R is from a combo box on the form. The...

Thank you :)

Hello, This is Craig. I have previously produced a database from scratch and learnt as much as i can by scouring the internet for snippets of code and ideas. It works well but i know that in the guts of it, it's a real mess. So, now I've joined here as I've created another database and want to...