English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

Please help

I am an accountant for an import house

But manual system is in use even today

I want MS access to organise my Import data

But under one B L which is the basis of Import file I have many containers with different sizes 20ft and 40ft and with different articles in

But access for the field of Container id I have created accepts one id only and relevant size

In design form I tried using tabular form putting all the unique fields in header portion .

But the data entry field only for the fields containerid , container size and container contents was put in details part

But when I started entering the container details the records gets automatically replaced with the container details in last record !!!

PLEASE HELP ME OUT

THANKS A LOT

2007-01-13 04:44:14 · 4 answers · asked by srevalsan 3 in Computers & Internet Programming & Design

4 answers

You've messed up your table design. Try again. I can't help you more than that because your English is awful.

2007-01-13 05:43:06 · answer #1 · answered by Anonymous · 0 0

Not quite sure I understand
I know with the limits place by Y!Answers, it can be difficult to detail complex ideas in the limited characters we have.

Again, don't know if any of these hit the mark, but . . .
- Size is set to the maximum you believe you'll need for a given field
- When you're importing data, you need to shape it to your data base -- using delimiters, otherwise you will fill/or get an error in an attempt to fill, the wrong column. Making your database useless in it's designed form.
- Build a sample data file, containing a few records with likely populated fields (null, or not), then attempt to import to check for possible design corrections.

You note "I want MS access to organize my Import data "
I'm not sure if you mean by "organize Import data", the data you're importing, or the data related to your Import business.

Access is designed to do the latter, but you must do the former(by design of DB or modifying of data).

Good luck -- hope I helped at least a little.

2007-01-13 09:16:45 · answer #2 · answered by Anonymous · 0 0

You need to use 2 tables. One master table for the main BL data and a 2nd detail table for the containers. The master table could be keyed on the BL number and the detail table would need to be keyed on 2 fields - I'd use the BL number and an 'autonumber' field.

You'd make a form for the master that showed a single record and a form for the detail that showed 'continuous' records. Then you'd drag the detail form into the master form as a sub-form.

2007-01-16 13:42:24 · answer #3 · answered by BillD 3 · 0 0

i ought to do a union between both tables. in reality, union creates a digital table containing both tables blended jointly. EG - elect table2.field1 FROM table2 the position table2.field1 isn't NULL UNION elect table1.field1 FROM table1 the position table1.field1 isn't NULL;

2016-11-23 16:03:04 · answer #4 · answered by akkash 4 · 0 0

fedest.com, questions and answers