Re: MI-L Mapbasic Code for a Data Entry Interface - HELP!!!

[Robert Crossley]

Belinda,
 
Why not set up an Access database for the data entry, and have a map table 
with the spatial representations of the spaces available as a map.
 
Then maintain a table for containers in Access.  If only one container is 
ever stored on one spot, you can simply have a field in the container 
database which references the spatial record for the spot.
 
Then use a workspace that contains the a query that has a join between the 
spatial table and the view can be used to display all the current info on 
the map.  You can maintain all the data about containers etc. in Access.  
When a container is exported, mark it with a spot ID that does not appear, 
and it will no longer appear in the query, but will still be contained in 
the database.  If you store your spatial data in Access database format, 
you can use that table's data as a lookup when you assign a container to 
it.
 
If more than one space is to be linked to a container or more than one 
container to be linked to a space, have a relational table that links the 
spatial data to the container (SPATIALID - CONTAINERID).  Then have a query 
in the Access database that has the container data and the spatial 
locations that it is stored at, and link to that view in Access instead of 
the container table.
 
No interface required.
 
R
 
On Wed, 23 Jul 2003 10:21:50 +1000, Belinda Scot <[EMAIL PROTECTED]> 
wrote:

Hi guys,

I need some expert help or advice. It is possible to derive a mbx or 
program to work out the following:

“My client owns a large storage space that can be divided into 500 
different containers of different sizes that is available for rent as 
storage areas for individual, supplier, wholesale people who need 
temporary space to store their items.

We have created the map for the storage areas. These containers have 
being assigned with an unique ID number.

Our questions are: Is it possible to write an application to allow us to 
track/update the container spot on every time when there is movement (on 
a monthly basis)? For instance Container 1 (Size XXX) has being exported 
after one month. A new supplier brought in a new container (Size AAA) and 
it will be entered onto Container 1 spot. And so on…

I supposed we are looking for data entry interface that will allow us to 
enter all the new details for the container that have just occupied spot 
1. This information is ITEM_DESCRIPTION, ITEM_CODE, ITEM_RENTAL_PRICE, 
RENTER_NAME, etc…

This is so that when we click on the map, it will provide us with an up- 
to-date information. This way is more efficient that having to upload an 
excel file each time there are new changes.

Thankx!

Cheerios,
BeLinda
_________________________________________________________________
Hot chart ringtones and polyphonics. Go to  
http://ninemsn.com.au/share/redir/adTrack.asp?mode=click&clientID=174&referral=Hotmail_taglines_plain&URL=http://ninemsn.com.au/mobilemania/default.asp

---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 7730



--

Robert Crossley Agtrix P/L
9 Short St
New Brighton 2483
Far Southern Queensland
AUSTRALIA
153.549004 E 28.517344 S

P: 02 6680 1309
F: New Connection
M: 0419 718 642
E: [EMAIL PROTECTED]
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 7733