Display contents of active cell

[mad-q]

Hello

I'm trying to have a cell display the information from which ever cell the cursors is on.

I am trying to use (Master Info / Child info) for a subform but would like the Master cell link to where ever the cursor is.

Is this even possible?

Thanks
Iain

 

[Mihail]

Access hasn't "cells".
Try to explain what you need to achieve.

 

[mad-q]

Hello

Sorry for that, Fields rather than cells.

What I am trying to do is the follows.

I have a master form which has a list of part numbers in several fields. When a user clicks on Field1 they are able to click on a subform and get information about the part number in Field1. This is using the Link Master Fields / Link Child fields options.

What I am trying to do is have the information in Link Master Fields not just tied to what is in Field1 but is tied to the active field that the user clicks on. So if they click on Field2 (which also has a part number in it) then the subform is able to find the details of the Part Number which is listed in Field2.

Many thanks
Iain

 

[Mihail]

Database Normalization and Table Structures - Microsoft Access / VBA

 

[mad-q]

Hello

Thank you for that, I am not sure if I am missing something within that text but breaking down the table isn't really the problem I have. I have the relationship already set and worked out.

Thanks
Iain

 

[Mihail]

Hello

Thank you for that, I am not sure if I am missing something within that text but breaking down the table isn't really the problem I have. I have the relationship already set and worked out.

Thanks
Iain

I'm not very sure about this. Can you post a pic with the relationships or the DB in Access 2003 format ?

 

[mad-q]

Re: Display contents of active field

Hello

Thank you so much for you work with this, I can't really attached the database as it is very large and also you would need the back end data to open the front end db. I have attached 2 screen shots, the first shows

Looking at screen1.jpg you can see in blue circle the current part number which is linked to a field (shown in orange circle) which when one clicks on the tab, Stock Info, it brings up the info on that part (see screen2.jpg).

What I would like is even if the user is clicking on the part number in the blue circle or field in the red circle they will be able to click on Stock Info and it will bring up either parts complete details.

Currently I have to have several, as you can see from the tabs, subforms all linking to different fields.

Once again, thank you very much.

Yours
Iain

 

[Mihail]

Your forms are amazing, beautiful and ... sexy but... not useful.
I asked for the relationships.

 

[mad-q]

Thank you for your kind words, please see attached a copy of the relationship. Going from left to right they are one to many relationships.

Yours
Iain

 

[Mihail]

Going from left to right they are one to many relationships

I don't think so

Do this:
Double click on each relationship (on the line you see in Relationships window)
Check the "Enforce Referential Integrity" checkbox.
I advice you to check the next two checkboxes as well.
Click OK.

What Access say ? Are you able to set the referential integrity ?

Other "advices":

Do not use spaces in names.
As examples, the table "Document Details" should be renamed as "DocumentDetails" and the field "Normal Supplier Tag" as "NormalSupplierTag".

Create tables for information of the same type:
As example, you have Address 1...4 and Alt Adress 1...4 for a customer.
I don't know what you store in this fields but I am pretty sure that you don't fill ALL this fields with data for each customer. Isn't it ?
So, a new table is required here:
tblAdresses
ID_Address (AutoNumber - PK)
CustNo (FK)
Address (Text)
IsAlt (Yes/No)

In this table you can also store more info like PostCode and anything else that is a "member" of a real address.

A general answer for your issues you can find in the link that I already give you in post #4. If is not enough, Google yourself and find out more about the DBs NORMALIZATION.

I don't know if this is the best practice but, my practice is to name the PK-FK the same:
So, if you have "CustNo" as PK in tblCustomers then is better for you to have the same name in tblDocument (no you have "Customer Number")

As you can see I use a prefix for each object: tblAdresses, qryCustomer (for a query),
frmCustomer for a form, rptCustomer for a report, cmbCustomer for a combobox, txt... for textboxes, lst for listboxes etc.

Even if you don't understand yet (now) why, try to do this. You will say a big THANK YOU soon.

But I repeat: Without to understand the NORMALIZATION concept you will never be able to create a DATABASE. Just some lists with data.

Good luck !

 

[mad-q]

Hello

Thank you for your comments and advice, I will certainly be reading more into it. The current database works perfectly. All links and relationships are working well.

My issue is that I would like a field to display the information from the field where the mouse cursor is. So whether you click on Name, address, phone number the field called LinkField will have either name, address... displayed in it when the mouse cursor is in the respective field.

Yours
Iain Gwynn