Question Split data base

[accessfleet]

I have just split my 2007DB. I also just noticed that AGST (Above Ground Storage Tank) table/form has lost some functionallity.

before the split a lookup field let you select the tank registration number. (Multipul locations have different numbers)

Since the split this stopped working.

I attempeded a work around by typing a default value in the properties for that field. It doen't work. I did this in both the FE and the BE still no default.

I am sort of new to all this. 9 months & counting. Could someone expain what changed, and why the default value doesn't work when it works perfectly in many other places in the DB?

 

[boblarson]

You don't by chance have lookups defined in the field at table level do you? If so, you shouldn't.

Also are all of your tables from the backend linked into the frontend?

 

[accessfleet]

I was learning how to use A2007 and I wanted to limit mechanic's typing requirments. They don't want to do it, They aren"t very good at it and many confuse sounds like with spelled like.

I was building the system like I wanted to be used and I did define the table field(s) as look-ups. It worked good as a single file.

As far as I know all DE tables are linked to the FE, at least when I do f11

all the tables show a right arrow before the table name.

I thought about changing the BE field properties, but shyed away when it told me to remove relationships. I really want to figure out how to fix one problem before creating multipul problems.

 

[boblarson]

...and I did define the table field(s) as look-ups. It worked good as a single file. .

Have you read this about why lookups at table level are not good? You use them at FORM level, not table level.

 

[accessfleet]

Thanks Bob:

I read the link you sent for the 1st time. I guess I still have a lot to learn. Access must be a good program. Even though I do things the wrong way the program still works pretty well.

I'll try and make any future projects free of any table level, look up fields. Any Idea's on how to fix what I had working before the split?

 

[boblarson]

Any Idea's on how to fix what I had working before the split?

You'll need to remove the lookups (see here for how) and then I believe you should be good to go. If that does't work, post back and we'll continue troubleshooting.

 

[accessfleet]

Thanks for the detail Bob. I changed to text box then changed field type to text and put default value in place and as soon as replaced the - with a . the data I need populates the field

Now if I can get the address to to work this will be a done deal..

John.